﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="WebDataProcessing.Index" %>
<%@ Register assembly="VitCode.Web.UI.PaginationGrid" namespace="VitCode.Web.UI" tagprefix="PaginationGrid" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title></title>
    <link href="ScriptFiles/CSS/Main.css" type="text/css" rel="stylesheet" />
    <link href="ScriptFiles/CSS/style.css" type="text/css" rel="Stylesheet" />
    <script src="ScriptFiles/JS/jquery.js" type="text/javascript"></script>
</head>
<body>
    <form id="form1" runat="server">
			<asp:Menu ID="pgMenu" Orientation="Horizontal" StaticMenuItemStyle-CssClass="tab"
                Font-Size="12px" StaticSelectedStyle-CssClass="selectedTab" 
                CssClass="tabs" runat="server" onmenuitemclick="pgMenu_MenuItemClick">
                <Items>
                <asp:MenuItem Text="数据库设置" Value="0"></asp:MenuItem>
                <asp:MenuItem Text="查询列表" Value="1"></asp:MenuItem>
                <asp:MenuItem Text="导入设置" Value="2"></asp:MenuItem>
                <asp:MenuItem Text="错误数据列表" Value="3"></asp:MenuItem>
                </Items>
            </asp:Menu>
			<table id="tblDB" width="100%" runat="server">
				<tr>
					<td style="HEIGHT: 25px">
						<asp:Label id="Label1" runat="server">数据库链接串</asp:Label>
						<asp:TextBox id="txtSqlConnStr" runat="server" Width="520px">Server=.\SqlExpress;initial catalog=NSCS_HK;User Id=sa;Password=vitcodesa</asp:TextBox></td>
				</tr>
				<tr>
					<td>
						<asp:TextBox id="txtTableName" runat="server" Width="152px"></asp:TextBox>&nbsp;&nbsp;&nbsp;
						<asp:Button id="btnSeachTable" runat="server" Text="查 找 表" 
                            onclick="btnSeachTable_Click"></asp:Button><FONT face="宋体">&nbsp;
						</FONT>
						<asp:DropDownList id="ddlTableName" runat="server" AutoPostBack="True" 
                            onselectedindexchanged="ddlTableName_SelectedIndexChanged1"></asp:DropDownList>&nbsp; 
						关键列&nbsp;
						<asp:DropDownList id="ddlKeyColName" runat="server"></asp:DropDownList></td>
				</tr>
			</table>
			<table id="tblQuery" width="100%" runat="server">
				<tr>
					<td><FONT face="宋体">查询条件：
							<asp:DropDownList id="ddlQueryColumn" runat="server"></asp:DropDownList>
							<asp:DropDownList id="ddlQueryType" runat="server">
								<asp:ListItem Value="等于" Selected="True">等于</asp:ListItem>
								<asp:ListItem Value="开始于">开始于</asp:ListItem>
								<asp:ListItem Value="包含">包含</asp:ListItem>
							</asp:DropDownList>
							<asp:TextBox id="txtQueryInfo" runat="server"></asp:TextBox>&nbsp;
							<asp:Button id="btnQuery" runat="server" Text="查   询" 
                            onclick="btnQuery_Click"></asp:Button>Top
							<asp:TextBox id="txtTop" runat="server" Width="48px">50</asp:TextBox>
							<asp:RangeValidator id="RangeValidator1" runat="server" 
                            ErrorMessage="要是填写,请填写0-500的整数" ControlToValidate="txtTop"
								Type="Integer" MaximumValue="50000" MinimumValue="0"></asp:RangeValidator></FONT></td>
				</tr>
				<tr>
					<td><PaginationGrid:PaginationGrid ID="pgList" Runat="server" DataFileFormat="Excel" AutoGenerateColumns="True" AutoSort="True" InitPageSize="30">
                        </PaginationGrid:PaginationGrid>
                    </td>
				</tr>
			</table>
			<table id="tblImport" width="100%" runat="server">
				<tr>
					<td>数据源文件：<INPUT id="fileSource" style="WIDTH: 415px; HEIGHT: 22px" type="file" size="50" name="fileSource"
							runat="server">
						<asp:label id="lblCheckSource" runat="server" ForeColor="Red"></asp:label></td>
				</tr>
				<tr>
					<td>工作表名称：<asp:textbox id="txtSheetName" Width="344px" Runat="server">sheet1</asp:textbox><asp:requiredfieldvalidator id="checkSheetName" runat="server" ErrorMessage="请填写工作表名称" ControlToValidate="txtSheetName"></asp:requiredfieldvalidator></td>
				</tr>
				<tr>
					<td>历史说明：<asp:TextBox id="txtHistoryMemo" runat="server" Width="344px"></asp:TextBox></td>
				</tr>
				<tr>
					<td style="HEIGHT: 27px"><asp:button id="btnCheckData" runat="server" Text="校验数据" 
                            onclick="btnCheckData_Click"></asp:button><FONT face="宋体">&nbsp;
							<asp:Button id="btnImport" runat="server" Text="导入数据" 
                            CausesValidation="False" Enabled="False" onclick="btnImport_Click"></asp:Button>
						</FONT><FONT face="宋体">导入文件名为：</FONT>
						<asp:Label id="lblFileName" runat="server" ForeColor="Green"></asp:Label>
						<asp:Button id="btnOutput" runat="server" Width="160" Text="模板导出(带检验信息)" 
                            Enabled="False" CausesValidation="False" onclick="btnOutput_Click"></asp:Button></td>
				</tr>
				<tr>
					<td><asp:label id="lblMessage" runat="server" ForeColor="#C00000"></asp:label></td>
				</tr>
				<tr>
					<td><PaginationGrid:PaginationGrid ID="pgError" Runat="server" DataFileFormat="Excel" AutoGenerateColumns="True" AutoSort="True" InitPageSize="30">
                        </PaginationGrid:PaginationGrid>
                    </td>
				</tr>
			</table>
			<table id="tlbErrorData" width="100%" runat="server">
				<tr>
					<td>
						<asp:CheckBox id="cbContainErrMsg" runat="server" AutoPostBack="True" Text="是否带出报错信息" Checked="True"></asp:CheckBox>
					</td>
				</tr>
				<tr>
					<td><PaginationGrid:PaginationGrid ID="pgErrorData" Runat="server" DataFileFormat="Excel" AutoGenerateColumns="True" AutoSort="True" InitPageSize="30">
                        </PaginationGrid:PaginationGrid>
                    </td>
				</tr>
			</table>
    </form>
</body>
</html>
